| Song | Album | Recording |
|---|---|---|
| Nightmare | Big Band Grooves | 399 |
| " | Moonglow | 488 |
| " | Best of the Big Bands, The | 1817 |
| " | Swing Era, Music of 1937-1938 | 5158 |
| " | Great Band Era - 12 Band Theme Songs | 6666 |
| " | Best of Artie Shaw, The | 10218 |
SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Nightmare"